package com.jushu.storbox.database;

import java.util.List;

import com.jushu.storbox.entities.AlbumFolderInfo;

public interface IAlbumFolderDao extends IBaseDao {

	//table name
		public static final String TABLE_NAME = "backup_album_folder_table";
		
		//fileds name
		public static final String OWNER_ID = "owner_id";
		public static final String FOLDER_PATH = "foldr_path";
		public static final String FOLDER_NAME = "folder_name";
		public static final String SERVER_FOLDER_ID = "server_folder_id";
		public static final String FOLDER_CREATEAT = "folder_createAt";
		public static final String FOLDER_REMOTE_NAME = "folder_remote_name";
		
		//table command
		public static final String TABLE_COMMAND = "Create table " + IAlbumFolderDao.TABLE_NAME +" ("
			+ IAlbumFolderDao.OWNER_ID +" text,"
			+ IAlbumFolderDao.FOLDER_PATH +" text,"
			+ IAlbumFolderDao.FOLDER_NAME +" text,"
			+ IAlbumFolderDao.SERVER_FOLDER_ID +" text,"
			+ IAlbumFolderDao.FOLDER_CREATEAT +" integer,"
			+ IAlbumFolderDao.FOLDER_REMOTE_NAME +" text,"
			+ "CONSTRAINT pk_tb_preupload_list PRIMARY KEY ("
			+ IAlbumFolderDao.OWNER_ID+","+IAlbumFolderDao.FOLDER_PATH +")"
			+ ")";
		
		public long insertAlbumFolder(AlbumFolderInfo albumFolder);
		public AlbumFolderInfo getAlbumFolder(String ownerId, String folderPath);
		public List<AlbumFolderInfo> getAlbumFolders(String ownerId);
		public void deleteAlumbFolderInfo(AlbumFolderInfo albumFolder);
		public int updateAlumbFolderInfo(AlbumFolderInfo albumFolder);
		public int clearByUserId(String ownerId);
}
